package com.yangjun.dao.mybatis.mapper.businessAnalysis;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface ChannelConversionMapper {
	public List<Map<String,Object>> queryAppUtmMediumData(@Param(value="startDay") String startDay,
			@Param(value="endDay") String endDay,@Param(value="siteidArr") String[] siteidArr,@Param(value="utmSourceArr") String[] utmSourceArr,
			@Param(value="sort") String sort);
	//查询一级渠道表格数据
	public List<Map<String,Object>> queryWebUtmMediumData(@Param(value="startDay") String startDay,
			@Param(value="endDay") String endDay,@Param(value="siteidArr") String[] siteidArr,@Param(value="utmMediumArr") String[] utmMediumArr
			,@Param(value="utmSourceArr") String[] utmSourceArr,@Param(value="isHasNullUtmSource") Boolean isHasNullUtmSource,
			@Param(value="sort") String sort);

	//查询二级渠道表格数据
	public List<Map<String,Object>> queryChannel2Data(@Param(value="startDay") String startDay,
			@Param(value="endDay") String endDay,@Param(value="siteidArr") String[] siteidArr
			,@Param(value="utmMediumArr") String[] utm_medium,@Param(value="utmSourceArr") String[] utm_source,@Param(value="isHasNullUtmSource") Boolean isHasNullUtmSource,
			@Param(value="sort") String sort,@Param(value="isMobile") Boolean isMobile);
	//获取最近30天数据
	public List<Map<String,Object>> queryMonthData(@Param(value="startDay") String startDay,
			@Param(value="endDay") String endDay,@Param(value="siteidArr") String[] siteidArr
			,@Param(value="utmMediumArr") String[] utm_medium,@Param(value="utmSourceArr") String[] utm_source,@Param(value="isHasNullUtmSource") Boolean isHasNullUtmSource,
			@Param(value="sort") String sort,@Param(value="isMobile") Boolean isMobile);
	//获取最近一年数据
	public List<Map<String,Object>> queryYearData(@Param(value="startDay") String startDay,
			@Param(value="endDay") String endDay,@Param(value="siteidArr") String[] siteidArr
			,@Param(value="utmMediumArr") String[] utm_medium,@Param(value="utmSourceArr") String[] utm_source,@Param(value="isHasNullUtmSource") Boolean isHasNullUtmSource,
			@Param(value="sort") String sort,@Param(value="isMobile") Boolean isMobile);
	//查询二级渠道维表
	public List<Map<String,Object>> queryUtmSourceDimension(@Param(value="siteidArr") String[] siteidArr,@Param(value="utmMediumArr") String[] utm_medium);

}
